/*Return data with the exception of the identified values*/ SELECT COLUMN1, COLUMN2 ... FROM SCHEMA_NAME.TABLE_NAME WHERE NOT (COLUMN1 LIKE '%VALUE%');